mail.altrad.com/2015.02.mail.altrad.com.tar/mail.altrad.com/TEST/office deutch/ACCESS.NL-NL/ACCLR.CAB/ACCESS_TEMPLATE_SALESPIPELINE.ACCDT_1043/template/database/objects/queryEmployeesExtendedFlipAddress.txt

Text File | 2006-11-12 | 4KB | 105 lines

Operation =1
Option =0
Begin InputTables
    Name ="Employees"
End
Begin OutputColumns
    Alias ="File As"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Alias ="Employee Name"
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Expression ="Employees.*"
End
Begin OrderBy
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Flag =0
    Expression ="IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & \" \" & [First Name]))"
    Flag =0
End
dbBoolean "ReturnsRecords" ="-1"
dbInteger "ODBCTimeout" ="60"
dbByte "RecordsetType" ="0"
dbBoolean "OrderByOn" ="0"
dbByte "Orientation" ="0"
dbByte "DefaultView" ="2"
dbBoolean "FilterOnLoad" ="0"
dbBoolean "OrderByOnLoad" ="-1"
dbBoolean "TotalsRow" ="0"
dbLongBinary "DOL" = Begin
    0x0acc0e55000000001e8ccb1c4c4d044a97af5df3827279e300000000ae9675f4 ,
    0x570ae340010000004029283445006d0070006c006f0079006500650073000000 ,
    0x000000007a2fcb4b5d086b4fbbdca0d80fb9eb1007000000c01ef7baa3de7046 ,
    0xaf332f94cad59338460069006c0065002000410073000000000000008b22150c ,
    0x5ba9c9468e86487f5a2b7f5e07000000c01ef7baa3de7046af332f94cad59338 ,
    0x45006d0070006c006f0079006500650020004e0061006d006500000000000000 ,
    0xe508591dde2ea24cb52622e4e226f077070000001e8ccb1c4c4d044a97af5df3 ,
    0x827279e34c0061007300740020004e0061006d00650000000000000050735262 ,
    0x51ca824b92e93051272b03f9070000001e8ccb1c4c4d044a97af5df3827279e3 ,
    0x4600690072007300740020004e0061006d00650000000000000055ca69e1f55a ,
    0x6f429353edbddf972ed9070000001e8ccb1c4c4d044a97af5df3827279e34300 ,
    0x6f006d00700061006e0079000000000000000000000000000000000000000000 ,
    0x00000c000000040000000000000000000000000000000000 ,
    0x0acc0e55000000001e8ccb1c4c4d044a97af5df3827279e300000000367a98ef ,
    0x570ae340010000004029283445006d0070006c006f0079006500650073000000 ,
    0x0000000029b6a9aeceeaf24bab160af1d3ac75fd0700000081511bd85e600044 ,
    0x8fcaa5b2e71fd92f460069006c0065002000410073000000000000007891cb57 ,
    0x453f454682b9ca402820eac90700000081511bd85e6000448fcaa5b2e71fd92f ,
    0x45006d0070006c006f0079006500650020004e0061006d006500000000000000 ,
    0xe508591dde2ea24cb52622e4e226f077070000001e8ccb1c4c4d044a97af5df3 ,
    0x827279e34c0061007300740020004e0061006d00650000000000000050735262 ,
    0x51ca824b92e93051272b03f9070000001e8ccb1c4c4d044a97af5df3827279e3 ,
    0x4600690072007300740020004e0061006d00650000000000000055ca69e1f55a ,
    0x6f429353edbddf972ed9070000001e8ccb1c4c4d044a97af5df3827279e34300 ,
    0x6f006d00700061006e0079000000000000000000000000000000000000000000 ,
    0x00000c000000040000000000000000000000000000000000
End
dbBinary "GUID" = Begin
    0xc01ef7baa3de7046af332f94cad59338
End
Begin
    Begin
        dbText "Name" ="Employee Name"
        dbInteger "ColumnWidth" ="1695"
        dbInteger "ColumnOrder" ="1"
        dbBoolean "ColumnHidden" ="0"
        dbMemo "SmartTags" ="\"urn:schemas-microsoft-com:office:smarttags#PersonName\""
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0x8b22150c5ba9c9468e86487f5a2b7f5e
        End
    End
    Begin
        dbText "Name" ="File As"
        dbInteger "ColumnWidth" ="1695"
        dbInteger "ColumnOrder" ="2"
        dbBoolean "ColumnHidden" ="0"
        dbLong "AggregateType" ="-1"
        dbBinary "GUID" = Begin
            0x7a2fcb4b5d086b4fbbdca0d80fb9eb10
        End
    End
End
Begin
    State =0
    Left =0
    Top =0
    Right =799
    Bottom =612
    Left =-1
    Top =-1
    Right =784
    Bottom =252
    Left =0
    Top =0
    ColumnsShown =539
    Begin
        Left =48
        Top =12
        Right =192
        Bottom =156
        Top =0
        Name ="Employees"
        Name =""
    End
End